package com.farm.learn.controller;

import com.farm.learn.domain.UserHour;
import com.farm.learn.service.PlaytimeServiceInter;
import com.farm.learn.service.UserhourServiceInter;
import com.farm.report.FarmReport;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.annotation.Resource;
import com.farm.web.easyui.EasyUiUtils;

import java.util.List;
import java.util.Map;

import org.apache.log4j.Logger;
import javax.servlet.http.HttpSession;
import com.farm.core.page.RequestMode;
import com.farm.authority.domain.Organization;
import com.farm.authority.service.OrganizationServiceInter;
import com.farm.core.page.OperateType;
import com.farm.core.sql.query.DBRule;
import com.farm.core.sql.query.DataQuery;
import com.farm.core.sql.result.DataResult;
import com.farm.core.sql.result.ResultsHandle;
import com.farm.core.page.ViewMode;
import com.farm.web.WebUtils;

/* *
 *功能：用户课时控制层
 *详细：
 *
 *版本：v0.1
 *作者：FarmCode代码工程
 *日期：20150707114057
 *说明：
 */
@RequestMapping("/userhour")
@Controller
public class UserhourController extends WebUtils {
	private final static Logger log = Logger.getLogger(UserhourController.class);
	@Resource
	private UserhourServiceInter userHourServiceImpl;
	@Resource
	private OrganizationServiceInter organizationServiceImpl;
	@Resource
	private PlaytimeServiceInter playTimeServiceImpl;

	/**
	 * 查询结果集合
	 * 
	 * @return
	 */
	@RequestMapping("/query")
	@ResponseBody
	public Map<String, Object> queryall(DataQuery query, HttpServletRequest request) {
		try {
			playTimeServiceImpl.loadPlayCache();
			query = EasyUiUtils.formatGridQuery(request, query);
			DBRule orgidRule = query.getAndRemoveRule("ORGID");
			if (orgidRule != null) {
				Organization org = organizationServiceImpl.getOrganizationEntity(orgidRule.getValue());
				query.addRule(new DBRule("D.TREECODE", org.getTreecode(), "like-"));
			}
			{
				DBRule rule = query.getAndRemoveRule("USERNAME");
				if (rule != null) {
					query.addSqlRule(" and h.USERID in (select id from alone_auth_user where NAME like '%"
							+ rule.getValue() + "%')");
				}
			}
			{
				DBRule rule = query.getAndRemoveRule("CLASSNAME");
				if (rule != null) {
					query.addSqlRule(" and h.CLASSID in (select id from WLP_L_CLASS where NAME like '%"
							+ rule.getValue() + "%')");
				}
			}
			{
				DBRule rule = query.getAndRemoveRule("HOURTITLE");
				if (rule != null) {
					query.addSqlRule(" and h.HOURID in (select id from WLP_L_CLASSHOUR where TITLE like '%"
							+ rule.getValue() + "%')"); 
				}
			}

			DataResult result = userHourServiceImpl.createUserhourSimpleQuery(query).search();

			// 加载更多的数据信息
			userHourServiceImpl.initMoreUserHourInfos(result.getResultList());
			result.runHandle(new ResultsHandle() {
				@Override
				public void handle(Map<String, Object> row) {
					if (row.get("LHOURSTATE").equals("1")) {
						row.put("DURATION", "100");
					}
					if (row.get("DURATION") == null) {
						row.put("DURATION", 0);
					}
					if (Integer.valueOf(row.get("DURATION").toString()) > 100) {
						row.put("DURATION", "100");
					}
				}
			});
			result.runformatTime("ETIME", "yyyy-MM-dd HH:mm");
			result.runformatTime("STIME", "yyyy-MM-dd HH:mm");
			result.runformatTime("LTIME", "yyyy-MM-dd HH:mm");
			result.runDictionary("1:完成,2:学习中", "PSTATE");

			return ViewMode.getInstance().putAttrs(EasyUiUtils.formatGridData(result)).returnObjMode();
		} catch (Exception e) {
			log.error(e.getMessage());
			return ViewMode.getInstance().setError(e.getMessage(), e).returnObjMode();
		}
	}

	/**
	 * 提交修改数据
	 * 
	 * @return
	 */
	@RequestMapping("/edit")
	@ResponseBody
	public Map<String, Object> editSubmit(UserHour entity, HttpSession session) {
		// TODO 自动生成代码,修改后请去除本注释
		try {
			entity = userHourServiceImpl.editUserhourEntity(entity, getCurrentUser(session));
			return ViewMode.getInstance().setOperate(OperateType.UPDATE).putAttr("entity", entity).returnObjMode();

		} catch (Exception e) {
			log.error(e.getMessage());
			return ViewMode.getInstance().setOperate(OperateType.UPDATE).setError(e.getMessage(), e).returnObjMode();
		}
	}

	/**
	 * 提交新增数据
	 * 
	 * @return
	 */
	@RequestMapping("/add")
	@ResponseBody
	public Map<String, Object> addSubmit(UserHour entity, HttpSession session) {
		// TODO 自动生成代码,修改后请去除本注释
		try {
			entity = userHourServiceImpl.insertUserhourEntity(entity, getCurrentUser(session));
			return ViewMode.getInstance().setOperate(OperateType.ADD).putAttr("entity", entity).returnObjMode();
		} catch (Exception e) {
			log.error(e.getMessage());
			return ViewMode.getInstance().setOperate(OperateType.ADD).setError(e.getMessage(), e).returnObjMode();
		}
	}

	/**
	 * 删除数据
	 * 
	 * @return
	 */
	@RequestMapping("/del")
	@ResponseBody
	public Map<String, Object> delSubmit(String ids, HttpSession session) {
		try {
			for (String id : parseIds(ids)) {
				userHourServiceImpl.deleteUserhourEntity(id, getCurrentUser(session));
			}
			return ViewMode.getInstance().returnObjMode();
		} catch (Exception e) {
			log.error(e.getMessage());
			return ViewMode.getInstance().setError(e.getMessage(), e).returnObjMode();
		}
	}

	@RequestMapping("/list")
	public ModelAndView index(HttpSession session) {
		return ViewMode.getInstance().returnModelAndView("learn/UserhourResult");
	}

	/**
	 * 显示详细信息（修改或浏览时）
	 *
	 * @return
	 */
	@RequestMapping("/form")
	public ModelAndView view(RequestMode pageset, String ids) {
		try {
			switch (pageset.getOperateType()) {
			case (0): {// 查看
				return ViewMode.getInstance().putAttr("pageset", pageset)
						.putAttr("entity", userHourServiceImpl.getUserhourEntity(ids))
						.returnModelAndView("learn/UserhourForm");
			}
			case (1): {// 新增
				return ViewMode.getInstance().putAttr("pageset", pageset).returnModelAndView("learn/UserhourForm");
			}
			case (2): {// 修改
				return ViewMode.getInstance().putAttr("pageset", pageset)
						.putAttr("entity", userHourServiceImpl.getUserhourEntity(ids))
						.returnModelAndView("learn/UserhourForm");
			}
			default:
				break;
			}
			return ViewMode.getInstance().returnModelAndView("learn/UserhourForm");
		} catch (Exception e) {
			return ViewMode.getInstance().setError(e + e.getMessage(), e).returnModelAndView("learn/UserhourForm");
		}
	}

	/**
	 * 下载文件
	 * 
	 * @return
	 */
	@RequestMapping("/exportExcel")
	public void download(String ruleText, HttpServletRequest request, HttpServletResponse response,
			HttpSession session) {
		try {
			DataQuery query = new DataQuery();
			query.setPagesize(5000);
			query.setNoCount();
			query.setRuleText(ruleText);
			Map<String, Object> result = queryall(query, request);
			FarmReport.newInstance("userHour.xls").addParameter("result", result.get("rows"))
					.addParameter("message",
							query.getPagesize() <= ((List) result.get("rows")).size()
									? "本报表仅展示前" + query.getPagesize() + "条记录"
									: "")
					.generateForHttp(response, "userHour");
		} catch (Exception e) {
			log.error(e.getMessage());
		}
	}
}
